Right Outer Join
Short Description
The Right Outer Join returns rows from the second input that match rows from the first input. Non matching rows from the second table are also returned, with joined columns set NULL
Detailed Description​
The Right Outer Join (also known as a Right Join) returns all rows from the second input along with matching rows from the first input. Non matching rows from the second table are returned, with missing values set NULL.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.